Data Grouping Process in Extended SQL Language Containing Fuzzy Elements
نویسندگان
چکیده
Incorporation of fuzziness into database systems allows to expand the analysis of data during the querying process. Approximate processing of data includes not only rows that exactly meet the search criteria, but also rows that are similar with the given range of tolerance. Queries formulated in natural language usually consist of imprecise and fuzzy terms. However, the implementation of the imprecision in query languages, such as SQL, requires additional extensions in a target database system. In the paper, we devote our attention to different methods of data grouping. In the first part of the paper we concentrate on the process of fuzzy grouping of crisp data. In the second part, we focus on the grouping of fuzzy data.
منابع مشابه
Processing of Crisp and Fuzzy Measures in the Fuzzy Data Warehouse for Global Natural Resources
Fuzzy Data Warehouse (FDW) is a data repository, which contains fuzzy data and allows fuzzy processing of the data. Incorporation of fuzziness into data warehouse systems gives the opportunity to process data at higher level of abstraction and improves the analysis of imprecise data. It also gives the possibility to express business indicators in natural language using terms, like: high, low, a...
متن کاملEfficient Processing of Nested Fuzzy SQL Queries in a Fuzzy Database
ÐIn a fuzzy relational database where a relation is a fuzzy set of tuples and ill-known data are represented by possibility distributions, nested fuzzy queries can be expressed in the Fuzzy SQL language, as defined in [25], [23]. Although it provides a very convenient way for users to express complex queries, a nested fuzzy query may be very inefficient to process with the naive evaluation meth...
متن کاملDATA ENGINEERII { G A publication of the IEEE Computer Society EEE TRANSACTIONS ON
ln a fuzzy relational database where a relation is atuzzy sel of tuples and ill-known data are represented by possibility distributions, nested fuzzy queries can be expressed in lhe Fuzzy SQL language, as defined in [25], [23]. Although it provides a very convenient way for users to express complex queries, a nested fuzzy query may be very inefficient to process with the naive evaluation method...
متن کاملSorting, Grouping and Duplicate Elimination in the Advanced Information Management Prototype
Sorting, duplicate suppression and grouping are important operations in relational database management systems. This paper is devoted to the related language features and their implementation in the Advanced Information Management Prototype AIM-P. The query language HDBL is an SQL-like database language supporting the extended NF* data model. The proposed language extensions follow the classica...
متن کاملPrioritized fuzzy logic based information processing in relational databases
Many years of research related to fuzzy logic and fuzzy set theory extensions to relational databases have not lead to stable implementations, standardized languages or fuzzy relational database application development tools and methods. The main goal of this paper is the modelling and the implementation of a set of tools that allow usage of fuzzy logic enriched with priorities in relational da...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2009